{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","INTEGRITY CATEGORIES","LEVEL 4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INTEGRITY CATEGORIES","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Generic ecological categories for EcoStatus components (modified from Kleynhans 1996 & Kleynhans 1999)."]
["ECOLOGICAL CATEGORY","GENERIC DESCRIPTION OF ECOLOGICAL CONDITIONS","ARBITRARY  GUIDELINE SCORE (% OF MAXIMUM THEORETICAL  TOTAL)"]
["A","Unmodified/natural, close to natural or close too predevelopment conditions  within the natural variability of the system drivers, hyrdology, physico-chemical and geomorphology. The habitat template and biological components can be considered close to natural or to pre-development conditions. The resilience of the system has not been compromised.",">92 - 100"]
["A/B","The system and its components are in a close to natural condition most of the time.  Conditions may rarely and temporarily decrease below the upper boundary of a B category.",">88 - <= 92"]
["B","Largely natural with few modifications. A small change in the attributes of natural habitats and biota may have taken place in terms of frequencies of occurrence and abundance.Ecosystem functions are essentially unchanged.",">82 - <=88"]
["B/C","Close to largely natural  most of the time. Conditions may rarely and temporarily decrease below the upper boundary of a C category.",">78 - <=82"]
["C","Moderately modified. Loss and change of natural habitat and biota have occurred in terms of  frequencies of occurrence and abundance. Basic ecosystem functions are still predominantly unchanged. The resilience of the system  to recover from human impacts has not been lost and it is ability to recover to a moderately modified condition following disturbance has been maintained.",">62 - <=78"]
["C/D","The system is in a close to moderately modified condition most of the time. Conditions may rarely and temporarily decrease below the upper boundary of a D category.",">58 - <=62"]
["D","Largely modified. A large change or loss of natural habitat, biota and basic ecosystem functions have occurred. The resilience of the system to maintain the category has not been compromised and the ability to deliver ecological goods and services have been maintained.",">42 - <=58"]
["D/E","The system is in a close to largely modified condition most of the time.Conditions may rarely and temporarily decrease below the upper boundary of a E category.The resilience of the system is often under severe stress and may be lost permanently if adverse impacts continue.",">38 - <=42"]
["E","Seriously modified. The change in the natural habitat template, biota and basic ecosystem functions are extensive. Only resilient biota may survive and it is highly likely that invasive and problem (pest) species  may dominate. The resilience of the system is severely compromised as is the capacity to provide ecological goods and services. However, geomorphological conditions are largely intact but extensive restoration may be required to improve the system's hydrology and physico-chemical conditions.","20 - <=38"]
["F","Critically / Extremely modified. Modifications have reached a critical level and the system has been modified completely with an almost complete change  of the natural habitat template, biota and basic ecoststem functions. Ecological goods and services have largely be been lost This is likely to include severe  catchment changes as well as hydrological, physico-chemical and geomorphological changes. In the worst instances the basic ecosystem functions have been destroyed and the changes are irreversible. Restoration of the system to a synthetic  but sustainable condition  acceptable for human purposes and to limit downstream impacts is the only option.","<20"]

{"sheet":"LEVEL 4","index":2,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[31,1,32,1],[33,1,35,1]]}
[null,"ENTER DATA IN GREY CELLS: \nDARK GREY = ENTER MANUALLY\nLIGHT GREY = DROP DOWN SELECTION LIST"]
[null,"INSTREAM BIOTA","IMPORTANCE SCORE","WEIGHT ","FRAI/FISHCON & MIRAI/INCON EC %","FRAI/FISHCON & MIRAI/INCON EC",null,"RATINGS",null,null,null,null,null,null,"WEIGHT","STANDARDISED WEIGHT","WEIGHTED RATING "]
[null,"FISH",null,null,null,null,null,1]
[null,"1.What is the natural diversity of fish species with different flow requirements",null,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C4=\"\",\"\",D4/$D$8),\"\")","v":""},{"$f":"IFERROR(C4*P4,\"\")","v":""}]
[null,"2.What is the natural diversity of fish species with a preference for different cover types",null,null,null,null,null,3,null,null,null,null,null,null,null,"",{"$f":"IFERROR(C5*P5,\"\")","v":""}]
[null,"3.What is the natural diversity of fish species with a preference for different flow depth classes",null,null,null,null,null,4,null,null,null,null,null,null,null,"",{"$f":"IFERROR(C6*P6,\"\")","v":""}]
[null,"4. What is the natural diversity  of fish species with various tolerances to modified water quality",null,null,null,null,null,5,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C7=\"\",\"\",D7/$D$8),\"\")","v":""},{"$f":"IFERROR(C7*P7,\"\")","v":""}]
[null,"FISH ECOLOGICAL CATEGORY (FRAI/FISHCON %)",{"$f":"IF(SUMIF(C4:C7,\">0\",C4:C7)=0,\"\",SUMIF(C4:C7,\">0\",C4:C7))","v":""},{"$f":"IF(SUMIF(D4:D7,\">0\",D4:D7)=0,\"\",SUMIF(D4:D7,\">0\",D4:D7))","v":""},null,{"$f":"IF(E8=\"\",\"\",IF(E8>=92,\"A\",IF(E8>=88,\"A/B\",IF(E8>=82,\"B\",IF(E8>=78,\"C/B\",IF(E8>=62,\"C\",IF(E8>=58,\"C/D\",IF(E8>=42,\"D\",IF(E8>=38,\"D/E\",IF(E8>=22,\"E\",IF(E8>=18,\"E/F\",IF(E8<18,\"F\",\"F\"))))))))))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Q8/Q14=0,\"\",Q8/Q14),\"\")","v":""},{"$f":"IFERROR(D8/$D$8,\"\")","v":""},{"$f":"IFERROR(AVERAGE(Q4:Q7),\"\")","v":""}]
[null,"AQUATIC INVERTEBRATES"]
[null,"1. What is the natural diversity of invertebrate biotopes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C10=\"\",\"\",D10/$D$13),\"\")","v":""},{"$f":"IFERROR(C10*P10,\"\")","v":""}]
[null,"2. What is the natural diversity of invertebrate taxa with different velocity requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C11=\"\",\"\",D11/$D$13),\"\")","v":""},{"$f":"IFERROR(C11*P11,\"\")","v":""}]
[null,"3. What is the natural diversity of invertebrate taxa with different tolerances to modified water quality",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(C12*P12,\"\")","v":""}]
[null,"AQUATIC INVERTEBRATE ECOLOGICAL CATEGORY (MIRAI/INCON  % )",{"$f":"IF(SUMIF(C9:C12,\">0\",C9:C12)=0,\"\",SUMIF(C9:C12,\">0\",C9:C12))","v":""},{"$f":"IF(SUMIF(D9:D12,\">0\",D9:D12)=0,\"\",SUMIF(D9:D12,\">0\",D9:D12))","v":""},null,{"$f":"IF(E13=\"\",\"\",IF(E13>=92,\"A\",IF(E13>=88,\"A/B\",IF(E13>=82,\"B\",IF(E13>=78,\"C/B\",IF(E13>=62,\"C\",IF(E13>=58,\"C/D\",IF(E13>=42,\"D\",IF(E13>=38,\"D/E\",IF(E13>=22,\"E\",IF(E13>=18,\"E/F\",IF(E13<18,\"F\",\"F\"))))))))))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Q13/Q14=0,\"\",Q13/Q14),\"\")","v":""},{"$f":"IFERROR(D13/$D$13,\"\")","v":""},{"$f":"IFERROR(AVERAGE(Q10:Q12),\"\")","v":""}]
[null,"INSTREAM  ECOLOGICAL CATEGORY (EC AND %): NOT CONFIDENCE RATED, ONLY FISH IN INVERTEBRATE INDICATOR RATINGS FOR WEIGHTING OF FRAI/FISHCON AND MIRAI/INCON CONSIDERED",null,{"$f":"IFERROR(D8+D13,\"\")","v":""},{"$f":"IFERROR((O8*E8)+(O13*E13),\"\")","v":""},{"$f":"IF(E14=\"\",\"\",IF(E14>=92,\"A\",IF(E14>=88,\"A/B\",IF(E14>=82,\"B\",IF(E14>=78,\"C/B\",IF(E14>=62,\"C\",IF(E14>=58,\"C/D\",IF(E14>=42,\"D\",IF(E14>=38,\"D/E\",IF(E14>=22,\"E\",IF(E14>=18,\"E/F\",IF(E14<18,\"F\",\"F\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(D14/$D$13,\"\")","v":""},{"$f":"IFERROR(IF(AND(Q8=\"\",Q13=\"\"),\"\",IF(SUM(Q8,Q13=0,0),SUM(Q8,Q13))),\"\")","v":""}]
[]
[null,"INSTREAM ECOLOGICAL CATEGORY: CONFIDENCE RATED","FRAI/FISHCON & MIRAI/INCON CONFIDENCE RATINGS",null,null,null,null,null,null,null,null,null,null,null,"PROPORITONS","MODIFIED WEIGHTS"]
[null,"Confidence rating for fish information",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(C8=\"\",E8=\"\",C17=\"\",C18=\"\"),\"\",AVERAGE(C17/C19,O8)),\"\")","v":""},{"$f":"IFERROR(IF(OR(O17=\"\",O18=\"\"),\"\",IF(O17=\"\",\"\",IF(O18=\"\",E8,IF(E8*O17=0,\"\",E8*O17)))),\"\")","v":""}]
[null,"Confidence rating for macro-invertebrate information",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(C13=\"\",E13=\"\",C18=\"\",C17=\"\"),\"\",AVERAGE(C18/C19,O13)),\"\")","v":""},{"$f":"IFERROR(IF(OR(O17=\"\",O18=\"\"),\"\",IF(O18=\"\",\"\",IF(C17=\"\",E13,IF(E13*O18=0,\"\",E13*O18)))),\"\")","v":""}]
[null,"INSTREAM ECOLOGICAL CATEGORY (%)",{"$f":"IF(SUMIF(C17:C18,\">0\",C17:C18)=0,\"\",SUMIF(C17:C18,\">0\",C17:C18))","v":""},{"$f":"(IF(AND(O17=\"\",O18=\"\"),\"\",IF(SUMIF(P17:P18,\">0\",P17:P18)=0,\"\",SUMIF(P17:P18,\">0\",P17:P18))))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF(O17:O18,\">0\",O17:O18)=0,\"\",SUMIF(O17:O18,\">0\",O17:O18))","v":""}]
[null,"INSTREAM ECOLOGICAL CATEOGORY",null,{"$f":"IF(D19=\"\",\"\",IF(D19>=92,\"A\",IF(AND(D19<92,D19>88),\"A/B\",IF(AND(D19>82,D19<=88),\"B\",IF(AND(D19>78,D19<=82),\"C/B\",IF(AND(D19>62,D19<=78),\"C\", IF(AND(D19>58,D19<=62),\"C/D\",IF(AND(D19>42,D19<=58),\"D\",IF(AND(D19>38,D19<=42),\"D/E\",IF(AND(D19>22,D19<38),\"E\",IF(AND(D19>18,D19<=22),\"E/F\",\"F\")))))))))))","v":""}]
[]
[null,"RIPARIAN VEGETATION","RIPARIAN VEGETATION (VEGRAI/VEGCON) EC %","RIPARIAN VEGETATION (VEGRAI/VEGCON) EC"]
[null,"RIPARIAN VEGETATION ECOLOGICAL CATEGORY",null,{"$f":"IF(C23=\"\",\"\",IF(C23=\"\",\"\",IF(C23>=92,\"A\",IF(AND(C23<92,C23>88),\"A/B\",IF(AND(C23>82,C23<=88),\"B\",IF(AND(C23>78,C23<=82),\"C/B\",IF(AND(C23>62,C23<=78),\"C\",IF(AND(C23>58,C23<=62),\"C/D\",IF(AND(C23>42,C23<=58),\"D\",IF(AND(C23>38,C23<=42),\"D/E\",IF(AND(C23>22,C23<38),\"E\",IF(AND(C23>18,C23<=22),\"E/F\",\"F\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,"PROPORITONS","MODIFIED WEIGHTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(C26/C28,\"\")","v":""},{"$f":"IFERROR(IF(OR(D19=\"\",C23=\"\"),\"\",D19*O24),\"\")","v":""}]
[null,"INTEGRATED (INSTREAM & RIPARIAN VEGETATION) ECOSTATUS","CONFIDENCE RATING ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(C27/C28,\"\")","v":""},{"$f":"IFERROR(IF(OR(C23=\"\",D19=\"\"),\"\",C23*O25),\"\")","v":""}]
[null,"Confidence rating for instream biological information",{"$f":"IFERROR(IF(C27=\"\",\"\",(C17*O17)+(C18*O18)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O24=\"\",O25=\"\"),\"\",SUM(O24:O25))","v":""}]
[null,"Confidence rating for riparian vegetation zone information"]
[null,"INTEGRATED ECOLOGICAL CATEGORY (%)",{"$f":"IF(OR(C26=\"\",C27=\"\"),\"\",SUM(C26:C27))","v":""},{"$f":"IFERROR(IF(OR(P24=\"\",P25=\"\"),\"\",SUM(P24:P25)),\"\")","v":""}]
[null,"INTEGRATED ECOSTATUS CATEGORY",null,{"$f":"IF(D28=\"\",\"\",IF(D28>=92,\"A\",IF(AND(D28<92,D28>88),\"A/B\",IF(AND(D28>82,D28<=88),\"B\",IF(AND(D28>78,D28<=82),\"C/B\",IF(AND(D28>62,D28<=78),\"C\", IF(AND(D28>58,D28<=62),\"C/D\",IF(AND(D28>42,D28<=58),\"D\",IF(AND(D28>38,D28<=42),\"D/E\",IF(AND(D28>22,D28<38),\"E\",IF(AND(D28>18,D28<=22),\"E/F\",\"F\")))))))))))","v":""}]